﻿using System;
using System.Data;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace KPIS.GERP.GFMS.IDAL
{
    public interface IDAL_FIM_SelectReports
    {
        DataTable SumUpBorrow(string BgYear, string BgmProj, string EmpName, DateTime? MoneyReqDateStart, DateTime? MoneyReqDateEnd, string bgm_source);
        DataTable SumUpPaymentCheque(string BgYear, string BankSeq, string BankAccSeq, DateTime? StartDate, DateTime? EndDate, string strChequeStatus);
        DataTable SumUpPaymentCheque(string BgYear, string BankSeq, string BankAccSeq, string startChequeBookNo, string endChequeBookNo, string strChequeStatus);
        DataTable MoneyRequestNotPay(string bgm_source_seq);
        DataTable Receives(DateTime? StartDate, DateTime? EndDate, string bgm_source_seq);
        //Adding on 23/9/57
        DataTable Receives(DateTime? StartDate, DateTime? EndDate, string bgm_source_seq, string receive_mode);
        //Adding on 27/6/57
        //DataTable SumUpPaymentChequeHeader(string BgYear, string BankSeq, string BankAccSeq, DateTime? StartDate, DateTime? EndDate, string strChequeStatus);
        //DataTable SumUpPaymentChequeDetail(string BgYear, string BankSeq, string BankAccSeq, DateTime? StartDate, DateTime? EndDate, string strChequeStatus,string chequeno);
        DataTable SumUpPaymentChequeHeader(string BgYear, string BankSeq, string BankAccSeq
            , string startChequeBookNo, DateTime? StartDate, DateTime? EndDate, string strChequeStatus);
        DataTable SumUpPaymentChequeDetail(string chequeSeq);
    }
}
